SUBSTR(TIME,7,2)+SUBSTR(TIME,1,6)
301:003010:00309:00308:00307:00306:00305:00304:00303:00302:0030PM01:00N 12:00301:003010:00309:00308:00307:00306:00305:00304:00303:00302:0030AM01:00